/*
 Navicat Premium Data Transfer

 Source Server         :
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           :
 Source Schema         : boot-admin

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 09/09/2020 17:39:26
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_sys_dept
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_dept')
drop table   t_sys_dept

go
CREATE TABLE t_sys_dept  (
  version int NULL DEFAULT NULL ,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL ,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL ,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL ,
  id bigint NOT NULL PRIMARY KEY,
  name varchar(128)  NULL DEFAULT NULL ,
  leader varchar(128)  NULL DEFAULT NULL,
  phone varchar(32)  NULL DEFAULT NULL,
  email varchar(64)  NULL DEFAULT NULL,
  parent_id bigint NULL DEFAULT NULL,
  sort int NULL DEFAULT NULL,
  ancestors text  NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'name'
exec sys.sp_addextendedproperty 'MS_Description', '负责人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'leader'
exec sys.sp_addextendedproperty 'MS_Description', '电话', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'phone'
exec sys.sp_addextendedproperty 'MS_Description', '邮箱', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'email'
exec sys.sp_addextendedproperty 'MS_Description', '父级', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'parent_id'
exec sys.sp_addextendedproperty 'MS_Description', '排序', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'sort'
exec sys.sp_addextendedproperty 'MS_Description', '祖级关系', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'ancestors'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '部门', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dept', null, null

-- ----------------------------
-- Table structure for t_sys_dict
-- ----------------------------

if exists(select name from sys.tables where name='t_sys_dict')
    drop table t_sys_dict
go
CREATE TABLE t_sys_dict  (
       version int NULL DEFAULT NULL,
       create_user_id bigint NULL DEFAULT NULL,
       create_time datetime NULL DEFAULT NULL,
       update_user_id bigint NULL DEFAULT NULL,
       update_time datetime NULL DEFAULT NULL,
       is_enabled int NULL DEFAULT NULL,
       del_flag int NULL DEFAULT NULL,
       description varchar(512) NULL DEFAULT NULL,
       id bigint NOT NULL PRIMARY KEY,
       name varchar(128) NULL DEFAULT NULL,
       type varchar(128) NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '字典名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'name'
exec sys.sp_addextendedproperty 'MS_Description', '字典类型', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'type'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '数据字典', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict', null, null




-- ----------------------------
-- Table structure for t_sys_dict_entry
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_dict_entry')
drop table t_sys_dict_entry
go
CREATE TABLE t_sys_dict_entry  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL,
  description varchar(512) NULL DEFAULT NULL,
  id bigint NOT NULL PRIMARY KEY,
  parent_id bigint NOT NULL,
  name varchar(128) NULL DEFAULT NULL,
  value varchar(128) NULL DEFAULT NULL,
  sort int NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '字典id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'parent_id'
exec sys.sp_addextendedproperty 'MS_Description', '名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'name'
exec sys.sp_addextendedproperty 'MS_Description', '字典值', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'value'
exec sys.sp_addextendedproperty 'MS_Description', '排序', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'sort'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '数据字典项', 'SCHEMA', 'dbo', 'TABLE', 't_sys_dict_entry', null, null
-- alter table t_sys_dict_entry add create_user_id int NULL DEFAULT NULL 新增表字段



-- ----------------------------
-- Table structure for t_sys_job
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_job')
drop table t_sys_job
go
CREATE TABLE t_sys_job (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL,
  description varchar(512) NULL DEFAULT NULL,
  id bigint NOT NULL IDENTITY PRIMARY KEY,
  name varchar(128)  NULL DEFAULT NULL,
  group_name varchar(64)  NULL DEFAULT NULL ,
  bean_name varchar(3072)  NULL DEFAULT NULL ,
  bean_method varchar(128)  NULL DEFAULT NULL,
  method_params text NULL,
  cron varchar(128) NULL DEFAULT NULL,
  person_in_charge varchar(128) NULL DEFAULT NULL,
  email varchar(512) NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '任务名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'name'
exec sys.sp_addextendedproperty 'MS_Description', '任务组', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'group_name'
exec sys.sp_addextendedproperty 'MS_Description', 'Bean名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'bean_name'
exec sys.sp_addextendedproperty 'MS_Description', '方法名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'bean_method'
exec sys.sp_addextendedproperty 'MS_Description', '参数', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'method_params'
exec sys.sp_addextendedproperty 'MS_Description', 'cron表达式', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'cron'
exec sys.sp_addextendedproperty 'MS_Description', '负责人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'person_in_charge'
exec sys.sp_addextendedproperty 'MS_Description', '负责人邮箱', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'email'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '定时任务', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job', null, null

-- ----------------------------
-- Table structure for t_sys_job_log
-- ----------------------------

if exists(select name from sys.tables where name='t_sys_job_log')
drop table t_sys_job_log
go
CREATE TABLE t_sys_job_log  (
    version int NULL DEFAULT NULL,
    create_user_id bigint NULL DEFAULT NULL,
    create_time datetime NULL DEFAULT NULL ,
    update_user_id bigint NULL DEFAULT NULL,
    update_time datetime NULL DEFAULT NULL,
    is_enabled int NULL DEFAULT NULL,
    del_flag int NULL DEFAULT NULL,
    description varchar(512)  NULL DEFAULT NULL,
    id bigint NOT NULL IDENTITY PRIMARY KEY ,
    job_id bigint NULL DEFAULT NULL ,
    job_name varchar(128)  NULL DEFAULT NULL,
    job_group varchar(128)  NULL DEFAULT NULL ,
    invoke_target text  NULL,
    method_params text  NULL,
    job_message text  NULL,
    status int NULL DEFAULT NULL ,
    exception_info text  NULL,
    start_time datetime NULL DEFAULT NULL,
    end_time datetime NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '任务id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'job_id'
exec sys.sp_addextendedproperty 'MS_Description', '任务名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'job_name'
exec sys.sp_addextendedproperty 'MS_Description', '任务组', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'job_group'
exec sys.sp_addextendedproperty 'MS_Description', '调用目标', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'invoke_target'
exec sys.sp_addextendedproperty 'MS_Description', '日志信息', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'job_message'
exec sys.sp_addextendedproperty 'MS_Description', '调用参数', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'method_params'
exec sys.sp_addextendedproperty 'MS_Description', '状态 0失败1成功', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'status'
exec sys.sp_addextendedproperty 'MS_Description', '异常信息', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'exception_info'
exec sys.sp_addextendedproperty 'MS_Description', '开始时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'start_time'
exec sys.sp_addextendedproperty 'MS_Description', '结束时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'end_time'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '任务日志', 'SCHEMA', 'dbo', 'TABLE', 't_sys_job_log', null, null


-- ----------------------------
-- Table structure for t_sys_login_log
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_login_log')
drop table t_sys_login_log
go
CREATE TABLE t_sys_login_log  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL ,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL ,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL ,
  id bigint NOT NULL PRIMARY KEY,
  username varchar(128)  NULL DEFAULT NULL ,
  login_ip varchar(128)  NULL DEFAULT NULL,
  browser varchar(64)  NULL DEFAULT NULL,
  os varchar(64)  NULL DEFAULT NULL,
  status int NULL DEFAULT NULL,
  message text  NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '登录名', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'username'
exec sys.sp_addextendedproperty 'MS_Description', '登录ip', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'login_ip'
exec sys.sp_addextendedproperty 'MS_Description', '浏览器', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'browser'
exec sys.sp_addextendedproperty 'MS_Description', '操作系统', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'os'
exec sys.sp_addextendedproperty 'MS_Description', '登录状态', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'status'
exec sys.sp_addextendedproperty 'MS_Description', '登录信息', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'message'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '登录日志', 'SCHEMA', 'dbo', 'TABLE', 't_sys_login_log', null, null

-- ----------------------------
-- Table structure for t_sys_menu
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_menu')
drop table t_sys_menu
go
CREATE TABLE t_sys_menu  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL ,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL PRIMARY KEY ,
  name varchar(128)  NULL DEFAULT NULL,
  enname varchar(128)  NULL DEFAULT NULL ,
  parent_id bigint NULL DEFAULT NULL,
  path varchar(3072)  NULL DEFAULT NULL,
  component varchar(3072)  NULL DEFAULT NULL,
  icon varchar(128)  NULL DEFAULT NULL,
  sort int NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'name'
exec sys.sp_addextendedproperty 'MS_Description', '组件名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'enname'
exec sys.sp_addextendedproperty 'MS_Description', '父菜单id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'parent_id'
exec sys.sp_addextendedproperty 'MS_Description', '路由地址', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'path'
exec sys.sp_addextendedproperty 'MS_Description', '组件地址', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'component'
exec sys.sp_addextendedproperty 'MS_Description', '图标', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'icon'
exec sys.sp_addextendedproperty 'MS_Description', '展示顺序', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'sort'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '菜单', 'SCHEMA', 'dbo', 'TABLE', 't_sys_menu', null, null

-- ----------------------------
-- Table structure for t_sys_oper_log
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_oper_log')
drop table t_sys_oper_log
go
CREATE TABLE t_sys_oper_log  (
  version int NULL DEFAULT NULL ,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL PRIMARY KEY,
  username varchar(128)  NULL DEFAULT NULL,
  oper_type int NULL DEFAULT NULL,
  oper_ip varchar(128)  NULL DEFAULT NULL,
  status int NULL DEFAULT NULL,
  request_url varchar(3072)  NULL DEFAULT NULL,
  request_method varchar(128)  NULL DEFAULT NULL,
  oper_method varchar(3072)  NULL DEFAULT NULL ,
  request_params text  NULL,
  request_result text  NULL,
  error_message text  NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '操作人员', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'username'
exec sys.sp_addextendedproperty 'MS_Description', '操作类型', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'oper_type'
exec sys.sp_addextendedproperty 'MS_Description', '操作ip', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'oper_ip'
exec sys.sp_addextendedproperty 'MS_Description', '状态', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'status'
exec sys.sp_addextendedproperty 'MS_Description', '请求地址', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'request_url'
exec sys.sp_addextendedproperty 'MS_Description', '请求方法', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'request_method'
exec sys.sp_addextendedproperty 'MS_Description', '操作方法', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'oper_method'
exec sys.sp_addextendedproperty 'MS_Description', '请求参数', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'request_params'
exec sys.sp_addextendedproperty 'MS_Description', '响应参数', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'request_result'
exec sys.sp_addextendedproperty 'MS_Description', '错误信息', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'error_message'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '操作日志', 'SCHEMA', 'dbo', 'TABLE', 't_sys_oper_log', null, null


-- ----------------------------
-- Records of t_sys_oper_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_sys_permission
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_permission')
drop table t_sys_permission
    go
CREATE TABLE t_sys_permission  (
     version int NULL DEFAULT NULL ,
     create_user_id bigint NULL DEFAULT NULL ,
     create_time datetime NULL DEFAULT NULL ,
     update_user_id bigint NULL DEFAULT NULL,
     update_time datetime NULL DEFAULT NULL,
     is_enabled int NULL DEFAULT NULL,
     del_flag int NULL DEFAULT NULL,
     description varchar(512) NULL DEFAULT NULL,
     id bigint NOT NULL PRIMARY KEY,
     name varchar(128) NULL DEFAULT NULL,
     permission varchar(32) NULL DEFAULT NULL,
     menu_id bigint NULL DEFAULT NULL ,
     sort int NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'name'
exec sys.sp_addextendedproperty 'MS_Description', '标识符', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'permission'
exec sys.sp_addextendedproperty 'MS_Description', '菜单id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'menu_id'
exec sys.sp_addextendedproperty 'MS_Description', '排序', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'sort'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '权限', 'SCHEMA', 'dbo', 'TABLE', 't_sys_permission', null, null



-- ----------------------------
-- Table structure for t_sys_post
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_post')
drop table t_sys_post
    go
CREATE TABLE t_sys_post  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL PRIMARY KEY,
  name varchar(128)  NULL DEFAULT NULL,
  number varchar(64)  NULL DEFAULT NULL,
  sort int NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'name'
exec sys.sp_addextendedproperty 'MS_Description', '编码', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'number'
exec sys.sp_addextendedproperty 'MS_Description', '排序', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'sort'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '岗位', 'SCHEMA', 'dbo', 'TABLE', 't_sys_post', null, null

-- ----------------------------
-- Table structure for t_sys_role
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_role')
drop table t_sys_role
    go
CREATE TABLE t_sys_role  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL PRIMARY KEY,
  name varchar(128)  NULL DEFAULT NULL,
  code varchar(32)  NULL DEFAULT NULL,
  sort int NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '名称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'name'
exec sys.sp_addextendedproperty 'MS_Description', '标识', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'code'
exec sys.sp_addextendedproperty 'MS_Description', '排序', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'sort'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '角色', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role', null, null

-- ----------------------------
-- Table structure for t_sys_role_dept
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_role_dept')
drop table t_sys_role_dept
    go
CREATE TABLE t_sys_role_dept  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL PRIMARY KEY,
  role_id bigint NULL DEFAULT NULL,
  dept_id bigint NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '角色id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'role_id'
exec sys.sp_addextendedproperty 'MS_Description', '部门id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'dept_id'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '角色数据权限', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_dept', null, null


-- ----------------------------
-- Table structure for t_sys_role_permission
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_role_permission')
drop table t_sys_role_permission
    go
CREATE TABLE t_sys_role_permission  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL ,
  update_time datetime NULL DEFAULT NULL ,
  is_enabled int NULL DEFAULT NULL ,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL PRIMARY KEY,
  role_id bigint NULL DEFAULT NULL,
  permission_id bigint NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '角色id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'role_id'
exec sys.sp_addextendedproperty 'MS_Description', '权限id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'permission_id'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '角色权限', 'SCHEMA', 'dbo', 'TABLE', 't_sys_role_permission', null, null

-- ----------------------------
-- Records of t_sys_role_permission
-- ----------------------------

-- ----------------------------
-- Table structure for t_sys_user_account
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_user_account')
drop table t_sys_user_account
    go
CREATE TABLE t_sys_user_account  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL ,
  update_time datetime NULL DEFAULT NULL ,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL ,
  id bigint NOT NULL PRIMARY KEY,
  username varchar(32)  NULL DEFAULT NULL ,
  password varchar(64)  NULL DEFAULT NULL ,
  user_id bigint NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '用户账号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'username'
exec sys.sp_addextendedproperty 'MS_Description', '用户密码', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'password'
exec sys.sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'user_id'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '用户账号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_account', null, null


-- ----------------------------
-- Table structure for t_sys_user_info
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_user_info')
drop table t_sys_user_info
    go
CREATE TABLE t_sys_user_info  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL ,
  update_user_id bigint NULL DEFAULT NULL ,
  update_time datetime NULL DEFAULT NULL ,
  is_enabled int NULL DEFAULT NULL ,
  del_flag int NULL DEFAULT NULL,
  description varchar(512)  NULL DEFAULT NULL ,
  id bigint NOT NULL PRIMARY KEY,
  nick_name varchar(64)  NULL DEFAULT NULL ,
  phone_number varchar(32)  NULL DEFAULT NULL,
  gender int NULL DEFAULT NULL ,
  avatar varchar(3072)  NULL DEFAULT NULL ,
  email varchar(64)  NULL DEFAULT NULL,
  dept_id bigint NULL DEFAULT NULL,
  is_admin int NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '昵称', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'nick_name'
exec sys.sp_addextendedproperty 'MS_Description', '用户手机号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'phone_number'
exec sys.sp_addextendedproperty 'MS_Description', '性别', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'gender'
exec sys.sp_addextendedproperty 'MS_Description', '头像', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'avatar'
exec sys.sp_addextendedproperty 'MS_Description', '邮箱', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'email'
exec sys.sp_addextendedproperty 'MS_Description', '部门', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'dept_id'
exec sys.sp_addextendedproperty 'MS_Description', '是否为admin账号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'is_admin'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '用户信息', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_info', null, null


-- ----------------------------
-- Table structure for t_sys_user_post
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_user_post')
drop table t_sys_user_post
    go
CREATE TABLE t_sys_user_post  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL ,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL ,
  update_time datetime NULL DEFAULT NULL ,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL ,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL PRIMARY KEY  ,
  user_id bigint NULL DEFAULT NULL ,
  post_id bigint NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'user_id'
exec sys.sp_addextendedproperty 'MS_Description', '岗位id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'post_id'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '用户岗位', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_post', null, null
-- ----------------------------
-- Records of t_sys_user_post
-- ----------------------------

-- ----------------------------
-- Table structure for t_sys_user_role
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_user_role')
drop table t_sys_user_role
    go
CREATE TABLE t_sys_user_role  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL ,
  is_enabled int NULL DEFAULT NULL ,
  del_flag int NULL DEFAULT NULL ,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL ,
  user_id bigint NULL DEFAULT NULL ,
  role_id bigint NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'user_id'
exec sys.sp_addextendedproperty 'MS_Description', '角色id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'role_id'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '用户角色', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_role', null, null

-- ----------------------------
-- Table structure for t_sys_option
-- ----------------------------
if exists(select name from sys.tables where name='t_sys_option')
drop table t_sys_option
    go
CREATE TABLE t_sys_option  (
  version int NULL DEFAULT NULL,
  create_user_id bigint NULL DEFAULT NULL,
  create_time datetime NULL DEFAULT NULL,
  update_user_id bigint NULL DEFAULT NULL,
  update_time datetime NULL DEFAULT NULL,
  is_enabled int NULL DEFAULT NULL,
  del_flag int NULL DEFAULT NULL ,
  description varchar(512)  NULL DEFAULT NULL,
  id bigint NOT NULL IDENTITY PRIMARY KEY,
  option_key varchar(64)  NULL DEFAULT NULL,
  option_value varchar(1024)  NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', 'key', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'option_key'
exec sys.sp_addextendedproperty 'MS_Description', 'value', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'option_value'
exec sys.sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', 'options选项', 'SCHEMA', 'dbo', 'TABLE', 't_sys_option', null, null


if exists(select name from sys.tables where name='t_sys_data_permission')
drop table t_sys_data_permission
    go
CREATE TABLE t_sys_data_permission  (
   version int NULL DEFAULT NULL,
   create_user_id bigint NULL DEFAULT NULL,
   create_time datetime NULL DEFAULT NULL,
   update_user_id bigint NULL DEFAULT NULL,
   update_time datetime NULL DEFAULT NULL,
   is_enabled int NULL DEFAULT NULL,
   del_flag int NULL DEFAULT NULL ,
   description varchar(512)  NULL DEFAULT NULL,
   id bigint NOT NULL IDENTITY PRIMARY KEY,
   permission_type varchar(50)  NULL DEFAULT NULL,
   isrow int  NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '权限类型', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'permission_type'
exec sys.sp_addextendedproperty 'MS_Description', '是否是行权限', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'isrow'
exec sys.sp_addextendedproperty 'MS_Description', '描述', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'description'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '数据权限表', 'SCHEMA', 'dbo', 'TABLE', 't_sys_data_permission', null, null



if exists(select name from sys.tables where name='t_sys_user_data_type')
drop table t_sys_user_data_type
    go
CREATE TABLE t_sys_user_data_type  (
     version int NULL DEFAULT NULL,
     create_user_id bigint NULL DEFAULT NULL,
     create_time datetime NULL DEFAULT NULL,
     update_user_id bigint NULL DEFAULT NULL,
     update_time datetime NULL DEFAULT NULL,
     is_enabled int NULL DEFAULT NULL,
     del_flag int NULL DEFAULT NULL ,
     id bigint NOT NULL IDENTITY PRIMARY KEY,
     user_id bigint NOT NULL,
     isall int  NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'user_id'
exec sys.sp_addextendedproperty 'MS_Description', '是否自定义权限', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'isall'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '用户数据权限类型', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_type', null, null



if exists(select name from sys.tables where name='t_sys_user_data_permission')
drop table t_sys_user_data_permission
    go
CREATE TABLE t_sys_user_data_permission  (
    version int NULL DEFAULT NULL,
    create_user_id bigint NULL DEFAULT NULL,
    create_time datetime NULL DEFAULT NULL,
    update_user_id bigint NULL DEFAULT NULL,
    update_time datetime NULL DEFAULT NULL,
    is_enabled int NULL DEFAULT NULL,
    del_flag int NULL DEFAULT NULL ,
    id bigint NOT NULL IDENTITY PRIMARY KEY,
    user_id bigint NOT NULL,
    data_permission_id varchar(50)  NULL DEFAULT NULL,
    permission_val varchar(100)  NULL DEFAULT NULL
)
exec sys.sp_addextendedproperty 'MS_Description', 'id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'id'
exec sys.sp_addextendedproperty 'MS_Description', '用户id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'user_id'
exec sys.sp_addextendedproperty 'MS_Description', '权限类型id', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'data_permission_id'
exec sys.sp_addextendedproperty 'MS_Description', '权限值', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'permission_val'
exec sys.sp_addextendedproperty 'MS_Description', '版本号', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'version'
exec sys.sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'create_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'create_time'
exec sys.sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'update_user_id'
exec sys.sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'update_time'
exec sys.sp_addextendedproperty 'MS_Description', '是否启用', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'is_enabled'
exec sys.sp_addextendedproperty 'MS_Description', '是否删除', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', 'COLUMN', 'del_flag'
exec sys.sp_addextendedproperty 'MS_Description', '用户数据权限', 'SCHEMA', 'dbo', 'TABLE', 't_sys_user_data_permission', null, null



--给jxc_ck添加字段
alter table jxc_ck add version int NULL DEFAULT NULL
alter table jxc_ck add create_user_id bigint NULL DEFAULT NULL
alter table jxc_ck add create_time datetime NULL DEFAULT NULL
alter table jxc_ck add update_user_id bigint NULL DEFAULT NULL
alter table jxc_ck add update_time datetime NULL DEFAULT NULL
alter table jxc_ck add is_enabled int NULL DEFAULT NULL
alter table jxc_ck add del_flag int NULL DEFAULT NULL



-- ----------------------------
-- Records of t_sys_dept
-- ----------------------------
INSERT INTO t_sys_dept VALUES (2, -1, '2020-09-07 07:08:41', -1, '2020-09-06 23:19:45', 1, 0, NULL, 1301320317976760321, '华南分部', '超级管理员', NULL, NULL, -1, 0, '-1');
INSERT INTO t_sys_dept VALUES (1, -1, '2020-09-06 23:20:05', NULL, NULL, 1, 0, '', 1302748434335297538, '研发部', '超级管理员', '', '', 1301320317976760321, 3, '-1_1301320317976760321');
INSERT INTO t_sys_dept VALUES (1, -1, '2020-09-06 23:20:31', NULL, NULL, 1, 0, '', 1302748540644126722, '运维部', '超级管理员', '', '', 1301320317976760321, 4, '-1_1301320317976760321');
INSERT INTO t_sys_dept VALUES (1, -1, '2020-09-06 23:20:59', NULL, NULL, 1, 0, '', 1302748659170963458, '华北分部', '超级管理员', '', '', -1, 1, '-1');
INSERT INTO t_sys_dept VALUES (1, -1, '2020-09-06 23:21:21', NULL, NULL, 1, 0, '', 1302748750128640001, '测试部', '测试部', '', '', 1302748659170963458, 6, '-1_1302748659170963458');
INSERT INTO t_sys_dept VALUES (1, -1, '2020-09-06 23:21:38', NULL, NULL, 1, 0, '', 1302748821356310530, 'UI部门', '超级管理员', '', '', 1302748659170963458, 7, '-1_1302748659170963458');

-- ----------------------------
-- Records of t_sys_dict
-- ----------------------------
INSERT INTO t_sys_dict VALUES (3, -1, '2020-09-06 23:25:36', -1, '2020-09-07 07:04:35', 1, 0, '', 1302749820213030914, '用户性别', 'sys_user_gender');
INSERT INTO t_sys_dict VALUES (2, -1, '2020-09-06 23:29:51', -1, '2020-09-06 23:34:11', 1, 0, '', 1302750889848631298, '系统状态', 'sys_common_status');
INSERT INTO t_sys_dict VALUES (1, -1, '2020-09-07 04:57:10', NULL, NULL, 1, 0, '', 1302833264498651138, '任务分组', 'sys_job_group');
INSERT INTO t_sys_dict VALUES (1, -1, '2020-09-09 06:00:31', NULL, NULL, 1, 0, '', 1303573982095642626, '操作类型', 'sys_oper_type');
INSERT INTO t_sys_dict VALUES (1, -1, '2020-09-10 01:41:32', NULL, NULL, 1, 0, '', 1303871194717536257, '系统常量', 'sys_constant');

-- ----------------------------
-- Records of t_sys_dict_entry
-- ----------------------------
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-06 23:27:02', NULL, NULL, 1, 0, NULL, 1302750183850799106, 1302749820213030914, '男', '0', 1);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-06 23:28:21', NULL, NULL, 1, 0, NULL, 1302750511375609857, 1302749820213030914, '女', '1', 2);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-06 23:29:09', NULL, NULL, 1, 0, NULL, 1302750714396700673, 1302749820213030914, '未知', '2', 3);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-06 23:30:13', NULL, NULL, 1, 0, NULL, 1302750984195305474, 1302750889848631298, '禁用', '0', 1);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-06 23:30:27', NULL, NULL, 1, 0, NULL, 1302751041317531649, 1302750889848631298, '启用', '1', 0);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-07 04:57:37', NULL, NULL, 1, 0, NULL, 1302833377216376833, 1302833264498651138, '默认', 'DEFAULT', 1);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-07 04:59:13', NULL, NULL, 1, 0, NULL, 1302833778644824065, 1302833264498651138, '系统', 'SYSTEM', 2);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:00:52', NULL, NULL, 1, 0, NULL, 1303574068863209474, 1303573982095642626, '新增', '1', 1);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:01:13', NULL, NULL, 1, 0, NULL, 1303574158638092290, 1303573982095642626, '修改', '2', 2);
INSERT INTO t_sys_dict_entry VALUES (2, -1, '2020-09-09 06:01:26', -1, '2020-09-09 06:01:55', 1, 0, NULL, 1303574211159166978, 1303573982095642626, '删除', '3', 3);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:02:25', NULL, NULL, 1, 0, NULL, 1303574459608764417, 1303573982095642626, '授权', '4', 4);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:02:37', NULL, NULL, 1, 0, NULL, 1303574507927146498, 1303573982095642626, '导出', '5', 5);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:02:46', NULL, NULL, 1, 0, NULL, 1303574547710119938, 1303573982095642626, '导入', '6', 6);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:02:55', NULL, NULL, 1, 0, NULL, 1303574583936323585, 1303573982095642626, '强退', '7', 7);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:03:10', NULL, NULL, 1, 0, NULL, 1303574647953985538, 1303573982095642626, '清空数据', '8', 8);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:03:20', NULL, NULL, 1, 0, NULL, 1303574689183993858, 1303573982095642626, '执行', '9', 9);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-09 06:03:38', NULL, NULL, 1, 0, NULL, 1303574766149472258, 1303573982095642626, '其他', '0', 999);
INSERT INTO t_sys_dict_entry VALUES (1, -1, '2020-09-10 01:41:56', NULL, NULL, 1, 0, NULL, 1303871294541971458, 1303871194717536257, 'default_password', '123456', 1);

-- ----------------------------
-- Records of t_sys_job
-- ----------------------------
truncate table t_sys_job;

INSERT INTO t_sys_job VALUES (19, -1, '2020-09-08 00:24:33', -1, '2020-09-08 00:42:22', 0, 0, '', '测试01', 'SYSTEM', 'taskTest', 'params', '{\"java.lang.String\":\"test\"}', '0/10 * * * * ?', '超级管理员', '1278032416@qq.com');
INSERT INTO t_sys_job VALUES (3, -1, '2020-09-08 00:45:51', -1, '2020-09-08 00:46:07', 1, 1, '', '測試02', 'SYSTEM', 'TaskTest', 'multipleParams', '{java.lang.String:test,java.lang.Boolean:true,java.lang.Long:123L,java.lang.Double:123.03D,java.lang.Integer:123}', '0/10 * * * * ?', '', '');

-- ----------------------------
-- Records of t_sys_job_log
-- ----------------------------
truncate table t_sys_job_log;

-- ----------------------------
-- Records of t_sys_menu
-- ----------------------------
INSERT INTO t_sys_menu VALUES (1, -1, '2020-09-07 07:11:37', NULL, NULL, 1, 0, NULL, 1, '系统管理', 'systemManager', -1, '/boot/admin/system', '', 'fa fa-cogs', 10);
INSERT INTO t_sys_menu VALUES (3, -1, '2020-09-07 07:12:51', -1, '2020-09-07 03:34:09', 1, 0, NULL, 2, '菜单管理', 'menuManager', 1, '/boot/admin/system/menu', 'bootAdmin/system/menu/index', 'fa fa-th-list', 13);
INSERT INTO t_sys_menu VALUES (2, -1, '2020-09-06 23:16:12', -1, '2020-09-07 03:34:21', 1, 0, NULL, 1302747457825828866, '部门管理', 'deptManager', 1, '/boot/admin/system/dept', 'bootAdmin/system/dept/index', 'fa fa-sitemap', 14);
INSERT INTO t_sys_menu VALUES (2, -1, '2020-09-06 23:16:48', -1, '2020-09-07 03:34:01', 1, 0, NULL, 1302747607004639233, '角色管理', 'roleManager', 1, '/boot/admin/system/role', 'bootAdmin/system/role/index', 'fa fa-user-secret', 12);
INSERT INTO t_sys_menu VALUES (2, -1, '2020-09-06 23:17:47', -1, '2020-09-07 03:34:31', 1, 0, NULL, 1302747852438532097, '岗位管理', 'postManger', 1, '/boot/admin/system/post', 'bootAdmin/system/post/index', 'el-icon-postcard', 15);
INSERT INTO t_sys_menu VALUES (2, -1, '2020-09-06 23:18:23', -1, '2020-09-06 23:19:10', 1, 0, NULL, 1302748004347834370, '用户管理', 'userManager', 1, '/boot/admin/system/userList', 'bootAdmin/system/user/list/index', 'fa fa-users', 11);
INSERT INTO t_sys_menu VALUES (1, -1, '2020-09-06 23:18:56', NULL, NULL, 1, 0, NULL, 1302748141795176449, '字典管理', 'dictManager', 1, '/boot/admin/system/dict', 'bootAdmin/system/dict/index', 'fa fa-bookmark-o', 16);
INSERT INTO t_sys_menu VALUES (1, -1, '2020-09-07 03:38:20', NULL, NULL, 1, 0, NULL, 1302813425436504066, '任务调度', 'scheduleManager', 1, '/boot/admin/system/job', 'bootAdmin/system/job/index', 'fa fa-tasks', 17);
INSERT INTO t_sys_menu VALUES (1, -1, '2020-09-08 06:16:13', NULL, NULL, 1, 0, NULL, 1303215545302175746, '系统监控', 'monitorManager', -1, '/boot/admin/monitor', '', 'el-icon-monitor', 20);
INSERT INTO t_sys_menu VALUES (1, -1, '2020-09-08 06:17:58', NULL, NULL, 1, 0, NULL, 1303215983061684225, '在线用户', 'onlineUser', 1303215545302175746, '/boot/admin/monitor/online', 'bootAdmin/monitor/online/user/index', 'fa fa-user-circle', 21);
INSERT INTO t_sys_menu VALUES (3, -1, '2020-09-09 05:58:35', -1, '2020-09-09 06:06:47', 1, 0, NULL, 1303573496625926146, '操作日志', 'operLogManager', 1303215545302175746, '/boot/admin/monitor/operation/log', 'bootAdmin/monitor/operation/index', 'fa fa-address-book', 22);
INSERT INTO t_sys_menu VALUES (2, -1, '2020-09-09 08:31:31', -1, '2020-09-09 08:33:02', 1, 0, NULL, 1303611980636012546, '登录日志', 'loginLogManager', 1303215545302175746, '/boot/admin/monitor/log/login', 'bootAdmin/monitor/log/login/index', 'fa fa-file-text-o', 23);
INSERT INTO t_sys_menu VALUES (1, -1, '2020-09-15 05:17:36', NULL, NULL, 1, 0, NULL, 1305737508465725442, '消息管理', 'messageManager', -1, '/boot/admin/message', '', 'fa fa-comment-o', 30);
INSERT INTO t_sys_menu VALUES (1, -1, '2020-09-15 05:18:35', NULL, NULL, 1, 0, NULL, 1305737755229212674, '邮件设置', 'mailManager', 1305737508465725442, '/boot/admin/message/mail', 'bootAdmin/message/mail/index', 'el-icon-message', 31);

-- ----------------------------
-- Records of t_sys_permission
-- ----------------------------
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:42:03', NULL, NULL, 1, 0, '', 1303599531669086209, '用户查询', 'user:query', 1302748004347834370, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:42:44', NULL, NULL, 1, 0, '', 1303599704965144578, '角色查询', 'role:query', 1302747607004639233, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:43:02', NULL, NULL, 1, 0, '', 1303599778839420930, '菜单查询', 'menu:query', 2, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:43:23', NULL, NULL, 1, 0, '', 1303599867314069506, '部门查询', 'dept:query', 1302747457825828866, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:43:39', NULL, NULL, 1, 0, '', 1303599936679469058, '岗位查询', 'post:query', 1302747852438532097, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:43:59', NULL, NULL, 1, 0, '', 1303600019739271169, '字典查询', 'dict:query', 1302748141795176449, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:44:15', NULL, NULL, 1, 0, '', 1303600088454553601, '任务查询', 'job:query', 1302813425436504066, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:44:33', NULL, NULL, 1, 0, '', 1303600161578049538, '在线用户查询', 'online:user:query', 1303215983061684225, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 07:44:53', NULL, NULL, 1, 0, '', 1303600245443158017, '操作日志查询', 'oper:log:query', 1303573496625926146, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:06:55', NULL, NULL, 1, 0, '', 1303620891703312386, '用户新增', 'user:save', 1302748004347834370, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:07:13', NULL, NULL, 1, 0, '', 1303620964906500097, '用户修改', 'user:update', 1302748004347834370, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:07:29', NULL, NULL, 1, 0, '', 1303621032820670466, '用户删除', 'user:delete', 1302748004347834370, 4);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:14:46', NULL, NULL, 1, 0, '', 1303622865614077953, '用户密码重置', 'user:rest:password', 1302748004347834370, 5);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:17:31', NULL, NULL, 1, 0, '', 1303623556374003714, '角色新增', 'role:save', 1302747607004639233, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:17:44', NULL, NULL, 1, 0, '', 1303623613932437506, '角色修改', 'role:update', 1302747607004639233, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:18:15', NULL, NULL, 1, 0, '', 1303623741074374658, '角色删除', 'role:delete', 1302747607004639233, 4);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:19:42', NULL, NULL, 1, 0, '', 1303624109267156993, '角色权限分配', 'role:permission:save', 1302747607004639233, 5);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:20:28', NULL, NULL, 1, 0, '', 1303624298254106626, '菜单新增', 'menu:save', 2, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:20:42', NULL, NULL, 1, 0, '', 1303624356861116418, '菜单修改', 'menu:update', 2, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:21:09', NULL, NULL, 1, 0, '', 1303624470224764929, '菜单删除', 'menu:delete', 2, 4);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:22:18', NULL, NULL, 1, 0, '', 1303624760768397313, '部门新增', 'dept:save', 1302747457825828866, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:22:33', NULL, NULL, 1, 0, '', 1303624825390039041, '部门修改', 'dept:update', 1302747457825828866, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:22:59', NULL, NULL, 1, 0, '', 1303624933565333506, '部门删除', 'dept:delete', 1302747457825828866, 4);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:23:50', NULL, NULL, 1, 0, '', 1303625145641926657, '岗位新增', 'post:save', 1302747852438532097, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:24:07', NULL, NULL, 1, 0, '', 1303625218148859905, '岗位修改', 'post:update', 1302747852438532097, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:24:23', NULL, NULL, 1, 0, '', 1303625286843170817, '岗位删除', 'post:delete', 1302747852438532097, 4);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:25:38', NULL, NULL, 1, 0, '', 1303625601537605634, '字典新增', 'dict:save', 1302748141795176449, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:25:52', NULL, NULL, 1, 0, '', 1303625660408856578, '字典修改', 'dict:update', 1302748141795176449, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:26:07', NULL, NULL, 1, 0, '', 1303625720320294914, '字典删除', 'dict:delete', 1302748141795176449, 4);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:26:28', NULL, NULL, 1, 0, '', 1303625808648142849, '任务新增', 'job:save', 1302813425436504066, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:26:40', NULL, NULL, 1, 0, '', 1303625861810946050, '任务修改', 'job:update', 1302813425436504066, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:26:55', NULL, NULL, 1, 0, '', 1303625923207168002, '任务删除', 'job:remove', 1302813425436504066, 4);
INSERT INTO t_sys_permission VALUES (2, -1, '2020-09-09 09:27:45', -1, '2020-09-09 09:29:40', 1, 0, '', 1303626131441778689, '在线用户强退', 'online:user:logout', 1303215983061684225, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:30:28', NULL, NULL, 1, 0, '', 1303626818481356802, '操作日志删除', 'oper:log:delete', 1303573496625926146, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:30:49', NULL, NULL, 1, 0, '', 1303626905810960386, '操作日志清除', 'oper:log:clean', 1303573496625926146, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:31:14', NULL, NULL, 1, 0, '', 1303627009196359681, '登录日志查询', 'login:log:query', 1303611980636012546, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:31:39', NULL, NULL, 1, 0, '', 1303627115731681281, '登录日志删除', 'login:log:delete', 1303611980636012546, 2);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-09 09:31:56', NULL, NULL, 1, 0, '', 1303627184333717505, '登录日志清除', 'login:log:clean', 1303611980636012546, 3);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 00:57:41', NULL, NULL, 1, 0, '', 1303860158241234945, '权限查询', 'permission:query', 2, 5);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 00:58:17', NULL, NULL, 1, 0, '', 1303860308321820673, '权限新增', 'permission:save', 2, 6);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 00:58:37', NULL, NULL, 1, 0, '', 1303860394313441281, '权限修改', 'permission:update', 2, 7);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 00:58:52', NULL, NULL, 1, 0, '', 1303860457823592449, '权限删除', 'permission:delete', 2, 8);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 01:17:45', NULL, NULL, 1, 0, '', 1303865207134658561, '字典项查询', 'dict:entry:query', 1302748141795176449, 5);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 01:18:07', NULL, NULL, 1, 0, '', 1303865300629889026, '字典项新增', 'dict:entry:save', 1302748141795176449, 6);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 01:18:26', NULL, NULL, 1, 0, '', 1303865381466710018, '字典项修改', 'dict:entry:update', 1302748141795176449, 7);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 01:18:42', NULL, NULL, 1, 0, '', 1303865447745101825, '字典项删除', 'dict:entry:delete', 1302748141795176449, 8);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-10 01:23:12', NULL, NULL, 1, 0, '', 1303866580093935617, '立即执行', 'job:exec', 1302813425436504066, 5);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-15 05:22:04', NULL, NULL, 1, 0, '', 1305738631863914497, '邮件详情', 'mail:info', 1305737755229212674, 1);
INSERT INTO t_sys_permission VALUES (1, -1, '2020-09-15 05:22:23', NULL, NULL, 1, 0, '', 1305738710540668930, '邮件保存', 'mail:save', 1305737755229212674, 2);

-- ----------------------------
-- Records of t_sys_post
-- ----------------------------
INSERT INTO t_sys_post VALUES (1, -1, '2020-09-06 23:23:28', NULL, NULL, 1, 0, '', 1302749284118065153, '全栈开发', 'S001', 1);
INSERT INTO t_sys_post VALUES (1, -1, '2020-09-06 23:23:40', NULL, NULL, 1, 0, '', 1302749333476634626, '人事专员', 'S002', 2);
INSERT INTO t_sys_post VALUES (1, -1, '2020-09-06 23:23:58', NULL, NULL, 1, 0, '', 1302749408756002818, '产品经理', 'S003', 3);
INSERT INTO t_sys_post VALUES (1, -1, '2020-09-06 23:24:10', NULL, NULL, 1, 0, '', 1302749458869547010, '软件测试', 'S004', 4);

-- ----------------------------
-- Records of t_sys_role
-- ----------------------------
INSERT INTO t_sys_role VALUES (1, -1, '2020-09-06 23:23:00', NULL, NULL, 1, 0, NULL, 1302749167210229762, '超级管理员', 'ROLE_ADMINISTRATOR', 1);

-- ----------------------------
-- Records of t_sys_role_dept
-- ----------------------------
INSERT INTO t_sys_role_dept VALUES (1, -1, '2020-09-06 23:23:00', NULL, NULL, 1, 0, NULL, 1302749167365419010, 1302749167210229762, 1301320317976760321);
INSERT INTO t_sys_role_dept VALUES (1, -1, '2020-09-06 23:23:00', NULL, NULL, 1, 0, NULL, 1302749167394779138, 1302749167210229762, 1302748659170963458);
INSERT INTO t_sys_role_dept VALUES (1, -1, '2020-09-06 23:23:00', NULL, NULL, 1, 0, NULL, 1302749167398973442, 1302749167210229762, 1302748434335297538);
INSERT INTO t_sys_role_dept VALUES (1, -1, '2020-09-06 23:23:00', NULL, NULL, 1, 0, NULL, 1302749167398973443, 1302749167210229762, 1302748540644126722);
INSERT INTO t_sys_role_dept VALUES (1, -1, '2020-09-06 23:23:00', NULL, NULL, 1, 0, NULL, 1302749167398973444, 1302749167210229762, 1302748750128640001);
INSERT INTO t_sys_role_dept VALUES (1, -1, '2020-09-06 23:23:00', NULL, NULL, 1, 0, NULL, 1302749167398973445, 1302749167210229762, 1302748821356310530);

-- ----------------------------
-- Records of t_sys_user_account
-- ----------------------------
INSERT INTO t_sys_user_account VALUES (1, -1, NULL, NULL, NULL, 1, 0, NULL, 1298548255977635841, 'Administrator', '$2a$10$GX.Ecwhp2gxt9fIM9wClWuUt2kUD0YtotWvNUmHtN7ftt2DISf4mC', -1);

-- ----------------------------
-- Records of t_sys_user_info
-- ----------------------------
INSERT INTO t_sys_user_info VALUES (3, -1, NULL, -1, '2020-08-28 08:44:44', 1, 0, NULL, -1, '超级管理员', NULL, 1, '', '1278032416@qq.com', -1, 1);


-- ----------------------------
-- Records of t_sys_user_role
-- ----------------------------

-- ----------------------------
-- Records of t_sys_job_log
-- ----------------------------
truncate table t_sys_option;


SET FOREIGN_KEY_CHECKS = 1;
